package com.azt.data.utils;

import java.util.ArrayList;
import java.util.List;

import org.jeecgframework.poi.excel.entity.params.ExcelExportEntity;

/**
 * @ClassName: ExcelExportEntityUtil
 * @Description: 为Map导出excel定义标题
 * @author: zhaheng
 * @date: 2017年4月25日 下午6:25:03
 */
public class ExcelExportEntityUtil {

	public static final String USER_DETAIL_TITLE = "用户明细";
	public static final String TRADE_VIEW_TITLE = "交易概览";
	public static final String TRADE_DETAIL_TITLE = "交易明细";
	public static final String SHOP_VIEW_TITLE = "店铺概览";
	public static final String SHOP_DETAIL_TITLE = "店铺明细";
	public static final String INTEGRALCOIN_VIEW_TITLE = "积分安装币概览";
	public static final String INTEGRALCOIN_DETAIL_TITLE = "积分安装币明细";

	/** 用户明细 **/
	public static List<ExcelExportEntity> UserEntityList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("用户ID", "id"));
		entity.add(new ExcelExportEntity("手机号", "mobile"));
		entity.add(new ExcelExportEntity("邮箱", "email"));
		entity.add(new ExcelExportEntity("真实姓名", "realName"));
		entity.add(new ExcelExportEntity("注册时间", "registertime"));
		entity.add(new ExcelExportEntity("公司名称", "companyName"));
		entity.add(new ExcelExportEntity("采购商", "ispurchaser"));
		entity.add(new ExcelExportEntity("供应商", "isprovider"));
		entity.add(new ExcelExportEntity("登录次数", "logintimes"));
		entity.add(new ExcelExportEntity("用户角色", "roleNames"));
		entity.add(new ExcelExportEntity("状态", "state"));
		return entity;
	}

	public static List<ExcelExportEntity> CompanyListList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("企业ID", "id"));
		entity.add(new ExcelExportEntity("企业名称", "companyName"));
		entity.add(new ExcelExportEntity("采购商", "ispurchaser"));
		entity.add(new ExcelExportEntity("供应商", "isprovider"));
		entity.add(new ExcelExportEntity("认证时间", "registertime"));
		entity.add(new ExcelExportEntity("联系方式", "link"));
		entity.add(new ExcelExportEntity("审核状态", "auditState"));
		entity.add(new ExcelExportEntity("用户数", "usernum"));
		entity.add(new ExcelExportEntity("省份", "regProvince"));
		entity.add(new ExcelExportEntity("城市", "regCity"));
		entity.add(new ExcelExportEntity("主营类目", "categorys"));
		return entity;
	}

	public static List<ExcelExportEntity> UserCompanyList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("增加用户", "reguser"));
		entity.add(new ExcelExportEntity("增加公司", "regcompany"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}

	public static List<ExcelExportEntity> UserLogList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("用户ID", "userId"));
		entity.add(new ExcelExportEntity("登录时间", "loginTime"));
		entity.add(new ExcelExportEntity("登录方式", "loginType"));
		entity.add(new ExcelExportEntity("IP", "ip"));
		entity.add(new ExcelExportEntity("退出时间", "exitTime"));
		return entity;
	}
	public static List<ExcelExportEntity> HotList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("用户手机", "mobile"));
		entity.add(new ExcelExportEntity("用户邮箱", "email"));
		entity.add(new ExcelExportEntity("所属企业", "company"));
		entity.add(new ExcelExportEntity("活跃度", "hot"));
		return entity;
	}

	/** 用户明细END **/

	/** 交易概览 **/
	public static List<ExcelExportEntity> TradeOrderCountRateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("新增订单数量", "addOrder"));
		entity.add(new ExcelExportEntity("增长率", "growthRate"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}

	public static List<ExcelExportEntity> TradeOrderTotalRateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("新增订单金额", "addOrder"));
		entity.add(new ExcelExportEntity("增长率", "growthRate"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}

	public static List<ExcelExportEntity> TradeOrderCountTotalRateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("自盈商城总金额", "selfTotalPrice"));
		entity.add(new ExcelExportEntity("第三方总金额", "othertotalPrice"));
		entity.add(new ExcelExportEntity("总金额", "totalPrice"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}

	/** 交易概览END **/

	/**交易明细**/
	public static List<ExcelExportEntity> orderAmountCountPreMonthList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("订单总金额", "totalPrice"));
		entity.add(new ExcelExportEntity("订单总数量", "orderCount"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}
	
	public static List<ExcelExportEntity> selectOrderList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("订单号", "orderNumber"));
		entity.add(new ExcelExportEntity("采购商", "buyerCompany"));
		entity.add(new ExcelExportEntity("供应商", "sellerCompany"));
		entity.add(new ExcelExportEntity("订单类别", "orderType"));
		entity.add(new ExcelExportEntity("订单时间", "ordertime"));
		entity.add(new ExcelExportEntity("订单金额", "totalPrice"));
		entity.add(new ExcelExportEntity("订单产品数量", "totalQuantity"));
		entity.add(new ExcelExportEntity("订单状态", "state"));
		entity.add(new ExcelExportEntity("是否分批支付", "ifBatchPay"));
		entity.add(new ExcelExportEntity("是否分批发货", "ifBatchShip"));
		return entity;
	}
	
	public static List<ExcelExportEntity> orderTradeList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("订单号", "orderNumber"));
		entity.add(new ExcelExportEntity("支付流水号", "payNumber"));
		entity.add(new ExcelExportEntity("支付批次", "batchSeq"));
		entity.add(new ExcelExportEntity("应付金额", "totalPrice"));
		entity.add(new ExcelExportEntity("实付金额", "realPayPrice"));
		entity.add(new ExcelExportEntity("抵扣安装币数量", "decoins"));
		entity.add(new ExcelExportEntity("支付时间", "payTime"));
		entity.add(new ExcelExportEntity("支付方式", "payType"));
		entity.add(new ExcelExportEntity("支付结果", "payResult"));
		entity.add(new ExcelExportEntity("审核状态", "auditState"));
		return entity;
	}
	
	public static List<ExcelExportEntity> orderCustomerTradeList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("客单价", "customerPrice"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}
	public static List<ExcelExportEntity> bullerPriceList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("采购商", "companyName"));
		entity.add(new ExcelExportEntity("总金额", "totalPrice"));
		return entity;
	}
	public static List<ExcelExportEntity> sellerPriceList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("供应商", "companyName"));
		entity.add(new ExcelExportEntity("总金额", "totalPrice"));
		return entity;
	}

	public static List<ExcelExportEntity> ProjectsByMonthList(){
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();

	    entity.add(new ExcelExportEntity("时间", "getMonth"));
	    entity.add(new ExcelExportEntity("询价数量", "enquiryNums"));
	    entity.add(new ExcelExportEntity("报价数量", "quoteNums"));
		return entity;
	}
	public static List<ExcelExportEntity> AcceptQuoteList(){
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();

	    entity.add(new ExcelExportEntity("时间", "getMonth"));
	    entity.add(new ExcelExportEntity("被采纳数量", "aqs"));
		return entity;
	}
	public static List<ExcelExportEntity> enquiryList(){
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
	    entity.add(new ExcelExportEntity("项目名称", "projectName"));
	    entity.add(new ExcelExportEntity("询价单位", "companyName"));
	    entity.add(new ExcelExportEntity("询价名称", "enquiryName"));
	    entity.add(new ExcelExportEntity("询价日期", "pubdate"));
	    entity.add(new ExcelExportEntity("状态", "state"));
	    entity.add(new ExcelExportEntity("报价次数", "quotetimes"));
	    entity.add(new ExcelExportEntity("下单次数", "ordertimes"));
		return entity;
	}
	public static List<ExcelExportEntity> quoteList(){
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
	    entity.add(new ExcelExportEntity("项目名称", "projectName"));
	    entity.add(new ExcelExportEntity("询价名称", "enquiryName"));
	    entity.add(new ExcelExportEntity("询价公司", "enquiryCompany"));
	    entity.add(new ExcelExportEntity("报价公司", "quoteCompany"));
	    entity.add(new ExcelExportEntity("报价时间", "quoteDate"));
//	    entity.add(new ExcelExportEntity("报价金额", "totalPrice"));
	    entity.add(new ExcelExportEntity("是否下单", "ifOrder"));
	    entity.add(new ExcelExportEntity("报价状态", "state"));
		return entity;
	}
	public static List<ExcelExportEntity> enquiryNumList(){
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
	    entity.add(new ExcelExportEntity("采购商企业", "company"));
	    entity.add(new ExcelExportEntity("询价数量", "num"));
	    entity.add(new ExcelExportEntity("被报价数量", "eqNum"));
		return entity;
	}
	public static List<ExcelExportEntity> quoteNumList(){
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
	    entity.add(new ExcelExportEntity("供应商企业", "companyName"));
	    entity.add(new ExcelExportEntity("报价数量", "num"));
		return entity;
	}
	public static List<ExcelExportEntity> enquiryPriceList(){
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
	    entity.add(new ExcelExportEntity("日期", "time"));
	    entity.add(new ExcelExportEntity("询价金额", "price"));
		return entity;
	}

	
	/**交易明细END**/
	
	/** 店铺概览 **/
	public static List<ExcelExportEntity> ProductTotalRateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("自营商品订单金额", "addOrder"));
		entity.add(new ExcelExportEntity("增长率", "growthRate"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}

	public static List<ExcelExportEntity> ShopTotalRateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("第三方商品订单金额", "addOrder"));
		entity.add(new ExcelExportEntity("增长率", "growthRate"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}

	public static List<ExcelExportEntity> ProductCountRateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("商品数量", "addProduct"));
		entity.add(new ExcelExportEntity("增长率", "growthRate"));
		entity.add(new ExcelExportEntity("月份", "umonth"));
		return entity;
	}

	/** 店铺概览END **/
	
	/** 店铺明细 **/
	public static List<ExcelExportEntity> ProductList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("商品名称", "name"));
		entity.add(new ExcelExportEntity("供应商", "companyName"));
		entity.add(new ExcelExportEntity("型号", "model"));
		entity.add(new ExcelExportEntity("品牌", "brand"));
		entity.add(new ExcelExportEntity("品类", "categoryName"));
		entity.add(new ExcelExportEntity("规格", "skuStr"));
		entity.add(new ExcelExportEntity("市场价", "price"));
		entity.add(new ExcelExportEntity("会员价", "cenPrice"));
		entity.add(new ExcelExportEntity("集采价", "memberPrice"));
		entity.add(new ExcelExportEntity("爆品价", "hotPrice"));
		entity.add(new ExcelExportEntity("订单数量", "orderQuantity"));
		return entity;
	}
	public static List<ExcelExportEntity> ProductVisitList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("商品名称", "name"));
		entity.add(new ExcelExportEntity("供应商", "companyName"));
		entity.add(new ExcelExportEntity("品类", "cateName"));
		entity.add(new ExcelExportEntity("品牌", "brand"));
		entity.add(new ExcelExportEntity("是否自营", "ifSelf"));
		entity.add(new ExcelExportEntity("浏览次数", "visitTimes"));
		return entity;
	}
	public static List<ExcelExportEntity> ProductVisitDataList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("商品名称", "name"));
		entity.add(new ExcelExportEntity("用户姓名", "realName"));
		entity.add(new ExcelExportEntity("用户手机", "mobile"));
		entity.add(new ExcelExportEntity("用户邮箱", "email"));
		entity.add(new ExcelExportEntity("访问时间", "createtime"));
		return entity;
	}

	public static List<ExcelExportEntity> AllShopList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("供应商", "companyName"));
		entity.add(new ExcelExportEntity("产品数量", "quantity"));
		entity.add(new ExcelExportEntity("已成交数量", "dealQuantiy"));
		entity.add(new ExcelExportEntity("已成交金额", "dealTotalPrice"));
		entity.add(new ExcelExportEntity("是否集采供应商", "member"));
		return entity;
	}
	/** 店铺明细END **/
	
	/**积分安装币概览**/
	public static List<ExcelExportEntity> gainCoinDateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("安装币", "coinAmount"));
		entity.add(new ExcelExportEntity("月份", "createtime"));
		return entity;
	}
	
	public static List<ExcelExportEntity> usedCoinDateList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("安装币", "coinAmount"));
		entity.add(new ExcelExportEntity("月份", "createtime"));
		return entity;
	}
	
	public static List<ExcelExportEntity> gainIntegralList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("积分", "score"));
		entity.add(new ExcelExportEntity("月份", "createtime"));
		return entity;
	}
	
	public static List<ExcelExportEntity> usedIntegralList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("积分", "score"));
		entity.add(new ExcelExportEntity("月份", "createtime"));
		return entity;
	}
	
	/**积分安装币概览END**/
	
	
	/**积分安装币明细**/
	public static List<ExcelExportEntity> integralStreamList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("用户ID", "userId"));
		entity.add(new ExcelExportEntity("账户", "username"));
		entity.add(new ExcelExportEntity("数量", "score"));
		entity.add(new ExcelExportEntity("时间", "createtime"));
		entity.add(new ExcelExportEntity("描述", "ruleDescr"));
		return entity;
	}
	
	public static List<ExcelExportEntity> coinStreamList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("公司名称", "companyName"));
		entity.add(new ExcelExportEntity("数量", "coinAmount"));
		entity.add(new ExcelExportEntity("时间", "createtime"));
		entity.add(new ExcelExportEntity("描述", "descr"));
		return entity;
	}

	public static List<ExcelExportEntity> PingAnEbList() {
		List<ExcelExportEntity> entity = new ArrayList<ExcelExportEntity>();
		entity.add(new ExcelExportEntity("公司名称", "companyName"));
		entity.add(new ExcelExportEntity("会员子账号", "custAcctId"));
		entity.add(new ExcelExportEntity("安装通代码", "thirdCustId"));
		entity.add(new ExcelExportEntity("可用资金", "tranAmount"));
		entity.add(new ExcelExportEntity("冻结资金", "frozenAmount"));
		entity.add(new ExcelExportEntity("状态", "state"));
		entity.add(new ExcelExportEntity("注册时间", "createtime"));
		return entity;
	}
	
	/**积分安装币明细END**/
}
